UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cjO78976sWA7qPtufq0xVQsWB/yzRv2W8b3Im+3E6iQ='
WHERE
key_id = '1f009527b4f928a2a66260a0ca9722a59fa9f6568f9603b476156f8f2af65d8e'
AND (
token = 'cjO78976sWA7qPtufq0xVQsWB/yzRv2W8b3Im+3E6iQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)