UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XQ6XTLmrNZAD4QNwG1M3x2y3sRlF/C6m37JgPOhTrWU='
WHERE
key_id = '0cdd041db3dc946d412fb770e38077e499ee537033036efbd969e07f082c9a97'
AND (
token = 'XQ6XTLmrNZAD4QNwG1M3x2y3sRlF/C6m37JgPOhTrWU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)