UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8mZbwO89r3wqI6fMJ7fABNOImNv5UV/c5snTkrcZak4='
WHERE
key_id = '4b472826f965e783a243bed9a5a9ed0fdf6cb171947172a1c671bee1a7ee31e6'
AND (
token = '8mZbwO89r3wqI6fMJ7fABNOImNv5UV/c5snTkrcZak4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)