UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lX4t1bHgrQt9qz18u5ViaIJcZEelMIfiRkC+tdJT7sE='
WHERE
key_id = '20817ccfd9bc99e4c2d4859bdb1185d5d05bbcda8f4562338b13bbf3c6b5e473'
AND (
token = 'lX4t1bHgrQt9qz18u5ViaIJcZEelMIfiRkC+tdJT7sE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)