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