UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'diu7iZVnihHtJABMPBPBWUNJLc3fK8SavOcVaf3iMAE='
WHERE
key_id = 'a48ffc2034d6ad494afab0204bf73c8ec19869cc05b346d6034a2b4b1fdfb94d'
AND (
token = 'diu7iZVnihHtJABMPBPBWUNJLc3fK8SavOcVaf3iMAE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)