UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G2nSyMcmtUcQPjP7CXDSYO4CdmG5nuF6axuV5GyjcYQ='
WHERE
key_id = '581bbc35eca4774efadec44fa875e840fc44e8257e917c3aab6d929ed7b8bd8d'
AND (
token = 'G2nSyMcmtUcQPjP7CXDSYO4CdmG5nuF6axuV5GyjcYQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)