UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xh5WkdWMQ69pBDBI7nWrW6iEUcQRYw1MrrzrISTO2EQ='
WHERE
key_id = '54f20507bd711cc0e98eac35b7c1e0e80268949a3ac8ed475fbe8b1ecafe2f2e'
AND (
token = 'xh5WkdWMQ69pBDBI7nWrW6iEUcQRYw1MrrzrISTO2EQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)