UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qOGnidX4QUCigypLRydemiDqbPPSsUZIG49VYs+vJK8='
WHERE
key_id = '1478cdc1fdc981575fe3dcb448ec60d14260363fb326ecccf01a106a99e5dcf9'
AND (
token = 'qOGnidX4QUCigypLRydemiDqbPPSsUZIG49VYs+vJK8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)