UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lE9PtmQcF0sBhf3TmELzeBwZ4SdhSuEEZv81Vb8PkcM='
WHERE
key_id = '584a377a2520e1d6e5fdb588137b52f2b25dc2e4bec61eba3391b6336b4736e8'
AND (
token = 'lE9PtmQcF0sBhf3TmELzeBwZ4SdhSuEEZv81Vb8PkcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)