UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wr/GUxb5l4GtnFanM+y0+fr7EPAsJvF6toFGoas5s9k='
WHERE
key_id = 'ae28ff887b2dd376ce1ed979d12e12e98a7a648818f718f9002cddee783be5e1'
AND (
token = 'wr/GUxb5l4GtnFanM+y0+fr7EPAsJvF6toFGoas5s9k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)