UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L1FGLR9ryh72XXq9NuZCienPpybL/356mLzWeWQeELQ='
WHERE
key_id = '378002392d51418cb67b0bffb70b2563705c3e48daa52c6a065fddff7ee14d92'
AND (
token = 'L1FGLR9ryh72XXq9NuZCienPpybL/356mLzWeWQeELQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)