UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fXlWE923DC8NRkX/DDNzFV4V38GsGzyBKJcg6yhyk3o='
WHERE
key_id = 'e5030c1af1cb921dabadd56aad2eec12f764607fc6ea5307782b0c974269e271'
AND (
token = 'fXlWE923DC8NRkX/DDNzFV4V38GsGzyBKJcg6yhyk3o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)