UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2loqpkuddbtCXL1eVj0MMzvtne7vbRc1kLGmmMGafqs='
WHERE
key_id = 'ad9cd4fb3b539adbd2727ca2868be01281d564865c8b9724e9277f2af3ae45e2'
AND (
token = '2loqpkuddbtCXL1eVj0MMzvtne7vbRc1kLGmmMGafqs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)