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