UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U6Pe9Wipp/7316g+mNv7Jyogygq0DK3kEHymQAGiIsk='
WHERE
key_id = '7e7272e400e5247dfb4bb7b3dbe2fe147b4fe581a0fb2648e465fe6e38152847'
AND (
token = 'U6Pe9Wipp/7316g+mNv7Jyogygq0DK3kEHymQAGiIsk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)