UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'koqUVzR0XSI+f2ooQsZB7+sM45zKAVeelpifWHSzBi0='
WHERE
key_id = 'ae3a17c3c944d5ebd344e055c46df069f5d489f30e8b0b5049d4db62b308ccc6'
AND (
token = 'koqUVzR0XSI+f2ooQsZB7+sM45zKAVeelpifWHSzBi0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)