UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zZ24CeXTcdftRh2zoKUnyI1OxlZakb8eE6u7m4NlAzg='
WHERE
key_id = '4482205068ea798257fff32f9d82ae51cbd4ee056639cdf97166a7e7baf80edb'
AND (
token = 'zZ24CeXTcdftRh2zoKUnyI1OxlZakb8eE6u7m4NlAzg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)