UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hb+SP0nKFvy1HnKWX+kH//NdE70EPpH/x8Xzi5bAn34='
WHERE
key_id = '1df743b2d38158b502c0ab82d27e9f0026f624a01d9a4d92c43126e99befb792'
AND (
token = 'Hb+SP0nKFvy1HnKWX+kH//NdE70EPpH/x8Xzi5bAn34='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)