UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hLhpLZHY/YU/Tkx7U1wkzjkeEm5Kd1rITZm7mFWrLRY='
WHERE
key_id = '5bf3bf4026c75931056178eb3f63c9025d16396e575e00a1553c275bbac0e6ae'
AND (
token = 'hLhpLZHY/YU/Tkx7U1wkzjkeEm5Kd1rITZm7mFWrLRY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)