UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XZ06fK8XpSf5wwqxQ0bM06THTwwm7lxYO/MYVanBTtk='
WHERE
key_id = '1220356f3c5c09957a77f25da1dd6b82f5080672d457945ff28a09da65d16a99'
AND (
token = 'XZ06fK8XpSf5wwqxQ0bM06THTwwm7lxYO/MYVanBTtk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)