UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dktSkRZvZBzpRYl8IdcJZUAStwXlviGsd7HNN34S+Mw='
WHERE
key_id = '031416e97b721d5b7979fd03d672d3eb5651e120c0644822735d8eb4b39eb790'
AND (
token = 'dktSkRZvZBzpRYl8IdcJZUAStwXlviGsd7HNN34S+Mw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)