UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4F97ZEHOIqivS05i1lWmb3jVB2SHLQHqPLPsexbKDrE='
WHERE
key_id = '207ac4deffab9216d30f4e47d792fdfd83beb21bacdf557475ac2b0177bc8ffd'
AND (
token = '4F97ZEHOIqivS05i1lWmb3jVB2SHLQHqPLPsexbKDrE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)