UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z4wiqiV5UITYBuAiTEVA1QszcJ3UyA8hvDz6faqPW30='
WHERE
key_id = '4a53e0392ea6486ebbada6f59c8a0e279f3e7a8eb5dd747943b96e53aea24eee'
AND (
token = 'Z4wiqiV5UITYBuAiTEVA1QszcJ3UyA8hvDz6faqPW30='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)