UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o0PnhjDqpp9ltd42u57hjz87Y3H0ajELznxOAP6SjuI='
WHERE
key_id = '06b4b58e3213d7993e5bb1831104491a175b78b79a703b56ff4fbcb5e0694225'
AND (
token = 'o0PnhjDqpp9ltd42u57hjz87Y3H0ajELznxOAP6SjuI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)