UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P7HYsTTPJZw47KYwVPPmZ+lXbCOkyw9SgVaN603hyI8='
WHERE
key_id = 'fc10d9665438a89b43c83f0e385a15ccc2cd87d447eed3568ec07ffe58bb9fdb'
AND (
token = 'P7HYsTTPJZw47KYwVPPmZ+lXbCOkyw9SgVaN603hyI8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)