UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CtI2LL2I3kless5NsCfbynwSm0ChbAgNyIXGyZv+6Yc='
WHERE
key_id = 'ca8ba396cfd6811c9048f422ad0d812059acd39592572e7ee0af2346700096b5'
AND (
token = 'CtI2LL2I3kless5NsCfbynwSm0ChbAgNyIXGyZv+6Yc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)