UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '39QHk3F8WABprBzH8ch29tU8P584Go1Q+aqOrZAk3AA='
WHERE
key_id = '1d4ab7c3df16ce3165d4862aeb2b60558f6826e11ccbecd9b3eb5345eb9adbbb'
AND (
token = '39QHk3F8WABprBzH8ch29tU8P584Go1Q+aqOrZAk3AA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)