UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QskR9akxAKIam52I5vSSDacnEHpDQUFF+xd2l50Az78='
WHERE
key_id = 'e9325b053a4d4be5e1efd0b63e91b1ad7e1889b286add6d8c2b2b53255c0bdeb'
AND (
token = 'QskR9akxAKIam52I5vSSDacnEHpDQUFF+xd2l50Az78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)