UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bDxidANxJJHt7NdBzcYKJlNBtJ8uGMS5HM/2Ye2BzhE='
WHERE
key_id = 'f671f29375f590ef5e74b633ff330d3f60d605d592ac111f51531a4097db6bda'
AND (
token = 'bDxidANxJJHt7NdBzcYKJlNBtJ8uGMS5HM/2Ye2BzhE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)