UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qm6+oG6r3R3oMgcpfwzXWAjgIpbBgF0hUnbu6KSAUHI='
WHERE
key_id = 'ea4ce10db0d7dd2d3c878374ff04aa7b69053fea9e9bbebdb00c7f3401779415'
AND (
token = 'qm6+oG6r3R3oMgcpfwzXWAjgIpbBgF0hUnbu6KSAUHI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)