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