UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UOhWPUpuXh/gD0q/1YiQAeVkqEuBw6lUdGGqkcFskvU='
WHERE
key_id = 'b49b36cff29bdaa816c3aa784e2171730a6f2d3ea6fb6125c8b9b6ae288d8197'
AND (
token = 'UOhWPUpuXh/gD0q/1YiQAeVkqEuBw6lUdGGqkcFskvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)